A table defines information that you want to track in the form of records, which typically include properties such as company name, location, products, email, and phone.

Tables appear in Power Apps as one of three different types, which indicate how the table came into the environment, whether the table is managed or unmanaged, and whether it can be customized.

For more information about how components are customizable, see Managed properties.

For more information about managed and unmanaged customizations, see Managed and unmanaged solutions.

An activity can be thought of as any action for which an entry can be made on a calendar. An activity has time dimensions (start time, stop time, due date, and duration) that help determine when the action occurred or will occur. Activities also contain data that helps determine what action the activity represents, for example, subject and description. An activity can be opened, canceled, or completed. The completed status of an activity will have several sub-status values associated with it to clarify the way that the activity was completed.

Activity tables are a special kind of table that can only be owned by a user or team, but can鈥檛 be owned by an organization. When you create a table, you can specify it as a standard or activity table.

The following table lists activity tables that are available in a default environment.

When you can create a new custom activity table, you might create it to read instant message communications. Creating an activity table is different from creating a non-activity table because you don鈥檛 specify a primary column. All activity tables have a Primary Field set to Subject and other common columns that are defined by the Activity table. This allows all types of activities to be shown in a view where just the common columns are displayed.

To create a custom activity table, open the Advanced options section in the New table panel, select the Activity option from the Type drop-down list. After you select this, you鈥檒l see that Display in Activity menus is selected. This setting allows people to create this type of activity in the activity menus. This isn鈥檛 selected for activities that are typically associated with specific events and created behind using code or by a workflow. After you save the table, you can鈥檛 change these settings.

Enable activities to add activities to a table and use the Regarding lookup for the table.

To enable activities, Sign in to Power Apps.

On the left nav, select Data to expand it and then select Tables.

Select a table.

On the command bar, select Settings.

Expand Collaboration, and select Enable for activities and then choose Done.

Important

Once enabled this setting can't be disabled. If prompted, select Okay to confirm.

Select Save Table and then publish the table.

There are two different types of standard and custom table ownership. When you create a custom table the ownership options are User or team or Organization owned. Once a table is created, the ownership type can't be changed.

Notice that there are a few Dataverse system tables that are similar to standard tables but have a different type of ownership from organization and user or team ownership:

Important

After a custom table is created, you can鈥檛 change the ownership. Before you create a table, make sure that you choose the correct type of ownership. If you later determine that your custom table must be of a different type, you have to delete it and create a new one.

A virtual table is a custom table in Dataverse that has columns containing data from an external data source. Virtual tables appear in your app to users as regular table rows, but contain data that is sourced from an external database dynamically at runtime, such as an Azure SQL Database. Rows based on virtual tables are available in all clients including custom clients developed using the Dataverse web services. More information: Create and edit virtual tables that contain data from an external data source

Create tables Edit tables